How to: Spellcheck a table datasheet.
Solution:
Open the Table Datasheet view, use the 'Spelling...' command under the 'Tools' menu, and make selections and follow the instructions that appear.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Select the 'Tools' menu and select 'Spelling...'. (The Spelling dialog box appears, and the spellchecking begins.)
Spelling dialog box
4) If a spelling mistake is found, do one of the following:
a) To ignore this occurrence of the word and continue checking, click 'Ignore'.
b) To ignore ALL occurrences of the word in the open table and continue checking, click 'Ignore All'.
c) To ignore any mistakes found in the entire field, click 'Ignore <'Field Name'> Field', where <'Field Name'> is the name of the field currently being checked.
d) To change the spelling of this occurrence of the word and continue checking:
1] Either type the correct spelling in the 'Change To' box, or use the spelling Access suggests.
2] Click 'Change'.
e) To change the spelling of ALL occurrences of the word in the open table and continue checking:
1] Either type the correct spelling in the 'Change To' box, or use the spelling Access suggests.
2] Click 'Change All'.
f) To add the word to the dictionary and continue checking, click 'Add'.
NOTE: When the spellcheck is completed, a message appears saying 'Spell checking is complete.'
5) Click 'OK' to return to Access.
Spell check complete
NOTE: To end the spellcheck, click 'Cancel' at any time.